<?php  session_start();
require_once("../db_connect.php");
	if(!array_key_exists("user_id",$_SESSION)){
		header("Location: ../top.php");
	}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="../../css/css.css" type="text/css" />
<script type="text/javascript"
	src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js"></script>
<script type="text/javascript" src="../../js/jquery.corner.js"></script>
<script type="text/javascript">          $(document).ready(                  function() {                          $("#volunteer").click(function () {                                  $("#target").attr({                                          action: "./PHP/serch_function/index_search.php?target=volunteer"                                  });                          });                            $("#thread").click(function () {                                  $("#target").attr({                                          action: "./PHP/serch_function/index_search.php?target=threads"                                  });                          });                            $("#all").click(function () {                            });                            $("#pending").click(function () {                          });                            $("#activitiy").click(function () {                          });                            $('.box').corner();                          $('.box2').corner();                          $('.box3').corner();                          $('.box4').corner();                          <?php                                  echo array_key_exists("error",$_SESSION)?"login_error('".htmlspecialchars($_SESSION['error'],ENT_QUOTES,"UTF-8")."');":"";                                  unset($_SESSION["error"]);                          ?>          });          function login_error(error){                  alert(error);          }  </script>
<link rel="stylesheet" href="../../css/css.css" type="text/css" />
<title>ボランティア申請履歴</title>

</head>
<body>
<div id="container">
<div id="header" class="box4">
<div id="header_box">
<div id="title"></div>
<div id="search_box"><a href="#" id="volunteer">ボランティア</a>｜<a href="#"
	id="thread">掲示板</a>
<form method="post"
	action="search_function/search_display.php?target=volunteer"
	id="target"><input type="text" name="search_word"><br />
<input type="submit" value="検索する" id="search_button"></form>
</div>
</div>
</div>
		<div id="rightnavi" class="box">
		<?php if(empty($_SESSION["user_name"])&&empty($_SESSION["user_id"])){?>
			<h3>ログインフォーム</h3>
			<form method="post" action="./user_function/UserLogin.php">
				ID：　　<input type="text" name="id" size="10"><br />
				PASS：<input type="text" name="pass" size="10"><br />
				<input style="margin:10px 0 0 39px;" type="image" src="../img/login.png" alt="送信ボタン" name="submit" align="middle">
			</form>
			<a  href="./PHP/User_create.php"><img style="margin:-20px 0 0 39px;" src="../img/newuser.png" border="0"></a>
		<?php }else{?>
				<img src="../../img/kaiinlogo.png" id="kaiinlogo" />
				<p>ようこそ<?php echo $_SESSION['nick_name']?>さん！</p>
				<p><a href="user_infomation.php">会員情報表示</a></p>
				<p><a href="user_update.php">会員情報変更</a></p>
				<p><a href="user_display_application.php">申請中ボランティア</a></p>
				<p><a href="user_display_volunteer.php">提供中ボランティア</a></p>
				<p><a href="../volunteer_function/volunteer_information_insert.php">ボランティア作成</a></p>
				<p><a href="logout.php">ログアウト</a></p>
				<br />
		<?php }?>
		<img src="../../img/keizilogo.png" id="keizilogo" />
<ul class="menu_margin">
<div id="thread_title_look">
<?php

	//スレッド項目取得
	$sql = "SELECT t.thread_id,count(thread_name) as thread_count,t.thread_name,max(r.response_date) as response_date,t.thread_id FROM thread AS t LEFT OUTER JOIN response AS r ON t.thread_id = r.thread_id group by t.thread_name order by response_date desc limit 0,5";
	$sth = $db->query($sql);
	if (DB::isError($sth)) {
	  exit($sth->getMessage());
	}

	//スレッド表示
	while ($data = $sth->fetchRow(DB_FETCHMODE_ASSOC)) {
	  echo "<li><a href='../response.php?thread_id=".$data['thread_id']."'>";
	  echo mb_strlen($data['thread_name'])>=9?mb_substr($data['thread_name'],0,9)."...":$data['thread_name'];
	  echo "</a></li>";
	}
?>
				</ul>
		<div id="more"><a href="../PHP/thread.php" >もっと見る...</a></div>
	</div>
<div id="main" class="box3">
<h2 align="center">ボランティア申請履歴</h2>
<br />
<br />
<link rel="stylesheet" href="../../css/table_css.css" type="text/css" />
<table id="table-05" align="center">
	<div align="right"><a href="user_display_application.php?sql=all">全て</a>｜<a
		href="user_display_application.php?sql=pending">申請中</a>｜<a
		href="user_display_application.php?sql=activitiy">活動済</a></div>
	<tr>
		<th></th>
		<th>ボランティア名</th>
		<th>活動開始日</th>
		<th>活動終了日</th>
		<th></th>
	</tr>
	<?php  require_once("../db_connect.php");            $user_id = $_SESSION['user_id'];            $today =& $db->query("select current_date()");          $today =& array_shift($today->fetchRow(DB_FETCHMODE_ORDERED));            if (!empty($_GET['sql']))          {                  $target = htmlspecialchars($_GET['sql']);          }          else          {                  $target = "all";          }            switch ($target)          {                  case "all":                  $sql = "SELECT a.volunteer_information_id,v.volunteer_name,v.activity_date,v.end_time                                  FROM application a,volunteer_information v                                  WHERE a.volunteer_information_id = v.volunteer_information_id                                  AND a.user_id = ?                                  order by v.activity_date";                  break;                  case "pending":                    $sql = "SELECT a.volunteer_information_id,v.volunteer_name,v.activity_date,v.end_time                                  FROM application a,volunteer_information v                                  WHERE a.volunteer_information_id = v.volunteer_information_id                                  AND a.user_id = ?                                  AND v.end_time > ".$today."                                  order by v.activity_date";                  break;                  case "activitiy":                  $sql = "SELECT a.volunteer_information_id,v.volunteer_name,v.activity_date,v.end_time                                  FROM application a,volunteer_information v                                  WHERE a.volunteer_information_id = v.volunteer_information_id                                  AND a.user_id = ?                                  AND v.end_time < ".$today."                                  order by v.activity_date";                  break;                  default:                          $sql = "SELECT a.volunteer_information_id,v.volunteer_name,v.activity_date,v.end_time                                  FROM application a,volunteer_information v                                  WHERE a.volunteer_information_id = v.volunteer_information_id                                  AND a.user_id = ?                                  order by v.activity_date";                  break;          }          $res =& $db->query($sql, $user_id);            if (PEAR::isError($res)) {                  die($res->getMessage());          }            //自分が申請中のボランティア情報を表示する          //詳しく知りたい場合は「詳細」ボタンを押す↓          //display_volunteer_informatino.phpで詳細を表示する。          $count = 0;          while ($data =& $res->fetchRow(DB_FETCHMODE_ASSOC))          {                  $count = $count + 1;                  echo "<tr><td>".$count."</td><td>".$data['volunteer_name']."</td><td>".$data['activity_date']."</td><td>".$data['end_time']."</td><td><a href='../user_function/app_volunteer_information.php?volunteer_information_id=".$data['volunteer_information_id']."'>詳細</a></td></tr>";          }   ?>
</table>
</div>
<div id="space"></div>
</div>
</body>
</html>
